USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[RevengesInsert]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.RevengesInsert
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 08/29/08
-- Description:	Revenges Table Insert
-- =============================================
CREATE PROCEDURE RevengesInsert

		   @RevengeId int,
           @RevengeTime datetime,
           @Attacker_playerId varchar(30),
           @Victim_playerId varchar(30),
           @RoundId int,
           @MiniRoundId int,
           @MapId int,
           @LogId int,
           @DateTime datetime
	

AS
BEGIN

INSERT INTO [Revenges]
           ([RevengeId]
           ,[RevengeTime]
           ,[Attacker_playerId]
           ,[Victim_playerId]
           ,[RoundId]
           ,[MiniRoundId]
           ,[MapId]
           ,[LogId]
           ,[DateTime])
     VALUES
           (@RevengeId,
           @RevengeTime,
           @Attacker_playerId,
           @Victim_playerId,
           @RoundId,
           @MiniRoundId,
           @MapId,
           @LogId,
           @DateTime)
END
GO
